package com.zrt.springboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zrt.springboot.entity.SensorRegistered;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;


/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author 青哥哥
 * @since 2023-03-11
 */

@Mapper
public interface SensorRegisteredMapper extends BaseMapper<SensorRegistered> {
    @Select("select max_depth from graduate_design.sys_sensor_registered where sensor_id = #{sensorId}")
    double selectMax(String sensorId);

    @Select("select min_depth from graduate_design.sys_sensor_registered where sensor_id = #{sensorId}")
    double selectMin(String sensorId);
}
